package com.isoft.dailymanprovidor.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.isoft.dailymanprovidor.entity.MeetingReservation;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Update;

@Mapper
public interface MeetingReservationDao extends BaseMapper<MeetingReservation> {
    //新增会议室预约申请
    @Insert("INSERT INTO TMIM_SYSTEM.meeting_reservation (department, meetingtitle, meetingroomname, starttime, endtime,\n" +
            " participants, content, needlabel, labelcontent, meetingtype, applicant, screencasting, notes, materialupload, agendaupload)" +
            " VALUES(#{department},#{meetingtitle},#{meetingroomname},#{starttime},#{endtime},#{participants},#{content}" +
            ",#{needlabel},#{labelcontent},#{meetingtype},#{applicant},#{screencasting},#{notes},#{materialupload},#{agendaupload} ) ")
    public int addmeetingreservation(MeetingReservation meetingReservation);

    //预约管理审核
    @Update("update TMIM_SYSTEM.meeting_reservation set status=#{status} where ID=#{id}")
    public int Manupdatestatue(MeetingReservation meetingReservation);


}
